Labels:text | screenshot | number | document | font OCR: Parameters Description Collections Parameters, Properties. This allows you to apply parameters to queries and stored procedures Methods CreateParameter, Execute. In the case of Executes it allows you to execute a com- miane and return a Recordset:object. Properties ActiveConnection,CommandText CommandTimeout; CommandType, Name, Prepared, State. The CommandText proper- #Hets you define the SQL statement. The CommandTimeout property lets you set the number of seconds the provider will wait for the command to execute .. The Active Connection property associates the open connection with a Command object You can use this property to poss a valid connection string to a Command object For multiple objects; if this property is not set the ADO will create a new Connection object for each Command object. The Name property is called when you want to execute the Command object Figure 7: Parameters available for the Command object.
(2000).iso/visua/941/omahf107.gif){kind=small}
(2000).iso/visua/941/omahf106.gif){kind=link}
(2000).iso/visua/941/omahf108.gif){kind=link}